Release 10.1A: OpenEdge Development:
Progress Dynamics Advanced Development

Other useful data object functions

The following additional functions are supported for SDOs, including functions that return index information and functions that retrieve logic procedures.

indexInformation

This CHARACTER function is supported for SDOs. It returns index information for all the buffers in an SDO’s query. The indexes are separated by CHR(1). Field information is either qualified with the database and table name or CHR(2) is used as the table separator. The INPUT parameters for this function are:

pcQuery — This parameter indicates what information is needed:
All — All indexed fields.
Standard or ‘’ — All indexed fields excluding word indexes.
Word — Word indexes.
Unique — Unique indexes.
NonUnique — Non-nique indexes.
Primary — Primary index.
Info — (Meaningless if pcIndexInfo has a value ?).
plUseTableSep — This LOGICAL parameter indicates whether the information should be returned using a special table separator. If this parameter is TRUE then the data is returned with CHR(1) as the separator between indexes an Unknown value (?), then the returned field names are qualified; otherwise they remain as they are in pcIndexInfo.
pcIndexInfo — This CHARACTER parameter is either a signal to use the SDO query or a string of previously retrieved information. If the parameter has the Unknown value (?),then the function uses the query as the basis for returning information. In this case, if the plUseTableSep parameter is TRUE, then the field is returned with CHR(1) and CHR(2) qualifiers. Otherwise this parameter must be the index information in the exact same format as was returned from this same function in a previous call with the syntax indexInformation ('info', TRUE, ?). In addition, there is a parallel IndexInformation property that allows the function to be used with no database connection, or without forcing a call from client to server to retrieve information. The property value is set in the client SDO when it is initialized, so its value is always available on the client. You can use the value of the IndexInformation property as the INPUT pcIndexInfo parameter value to this function, in which case the function acts as a filtering and formatting mechanism to return to you just the information you need, in an appropriate format.

dataLogicProcedure, dataLogicObject

Use these SDO functions to retrieve the name of the SDO’s logic procedure, or its procedure handle, respectively.